from flask import Blueprint,request

from xlrd import open_workbook

bp_excel = Blueprint('excel',__name__)

@bp_excel.route('/excel1')
def excel1():
    name = 'static/files/1.xls'
    bk = open_workbook(name,encoding_override='utf-8')
    sh = bk.sheets()[0]
    nrows = sh.nrows
    ncols = sh.ncols
    for i in range(1,nrows):
        row_date = sh.row_values(i)
        print(row_date[0])
        print(row_date[1])
    return 'ok'